SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002696s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110686 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110686 [ RunTime:0.003153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412212,246873,634563,324811,778678,401688,331120,205673,565259,887043,732541,770785,248911,534007,37937,308852,803764,356192,545312,952282,257433,254173,567914,171781,346721,848231,564489,64840,382241,19542,487838,630247,844490,330222,154282,336666,606239,412042,453219,89744,206661,583899,387310,343436,541695,222780,369271,94946,456666,173594,945306,92260,505028,539960,874325,238813,1030933,188286,738424,107233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]