SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283643 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283643 [ RunTime:0.003966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483739,1002311,445774,385279,617706,672827,907125,453117,72185,1012821,281706,248935,715469,197478,6542,375948,12006,203511,746427,392109,269044,957907,1038579,45675,919284,762559,644692,864413,352216,827261,620425,730837,514235,951650,804459,130229,970360,68542,669956,94158,244719,984173,991823,139237,96601,654527,493106,254731,75495,990130,731368,662298,689760,969480,401002,699382,509702,522065,59185,364514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]