SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158596 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158596 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780209,1036104,404075,232175,832781,721728,547831,349745,513025,1040991,703730,211676,805764,19690,271482,490142,784872,532859,579139,430740,172981,719133,618941,877131,224285,834591,5595,152426,653578,143697,962102,578675,727444,44769,10655,1022873,545277,302699,561557,473408,162638,430982,514211,177487,637406,314386,699800,22911,298975,397425,44544,200632,943844,592202,312571,411823,733771,243704,486383,36179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]