SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407509 LIMIT 1 [ RunTime:0.002674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407509 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530320,294522,25087,249145,704287,845703,475840,985279,425392,321348,646904,720526,861216,1016398,729136,729418,297581,1007584,448409,385377,972243,773477,707207,822210,398729,908325,128937,475692,260894,119885,706039,924730,800562,596601,673859,626277,865344,126156,302483,545377,530142,298162,1007115,870319,814697,432251,825692,895807,610941,252386,706639,579889,218457,606017,344951,851900,34153,325196,794439,377998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]