SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335842 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335842 [ RunTime:0.003508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276988,211856,197072,211806,672872,745152,932010,52428,220730,17509,553433,806935,1006365,621180,550399,417690,193620,1022076,108353,668755,116976,905234,955435,705637,691945,395325,908440,760501,646291,651935,986372,643549,207604,348716,341551,654748,733176,415255,642096,660499,109559,101723,146240,723664,1018157,809923,883697,572346,822545,603582,957035,883289,976101,763510,278228,719218,291225,682220,607397,441174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]