SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416770 LIMIT 1 [ RunTime:0.000883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416770 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422708,339733,318181,868774,24313,549948,779330,902839,672095,383617,943690,60703,371874,496055,405682,152395,951521,226190,745822,392579,412263,910150,256412,853339,1004788,365247,613071,125670,764272,362576,72841,641725,946872,748802,1047619,998698,833304,532147,246953,165564,854369,804014,422868,836722,1032397,451510,810078,677429,996325,97543,866753,988304,847586,173606,598730,1034594,67371,519632,287698,515041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]