SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109003 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109003 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522106,965697,730586,212474,494509,388837,479626,665939,454975,460634,809640,748978,988754,492031,92780,466586,337574,655711,762011,158334,864475,637014,542736,399407,403245,204710,108128,424786,108803,409096,250709,382219,441828,29727,113840,472930,1004566,630138,852676,486731,478570,796023,155259,567684,676934,276251,782315,55387,760311,122906,1045893,636244,975335,905016,203366,960415,311272,865625,940877,302662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]