SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184013 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184013 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472490,410348,78116,312173,1038032,860469,841993,992136,98302,452412,1044918,879744,792300,441423,378751,309887,125885,951652,45813,70283,983260,413594,379814,240845,869552,997081,956487,283921,553621,441916,617317,102829,15416,406873,246866,364069,456166,207849,335550,647931,283709,812159,264926,772644,884381,933190,330437,466159,543872,206931,905332,516448,743106,306550,252302,98647,158970,412761,1039449,540685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]