SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597927 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597927 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576087,389573,297647,781281,937762,302560,301081,309234,68271,494769,664801,674699,260757,224184,289822,276181,132839,197070,174162,282530,516266,248465,455880,766889,425525,707587,325958,470164,702397,88242,683917,310369,1001814,692971,498981,425495,691499,35373,242165,528688,517997,962814,155541,777232,983821,1005281,287339,662473,780256,824868,810862,1043914,787940,257242,42430,945415,206577,694172,773479,247463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]