SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516878 LIMIT 1 [ RunTime:0.000717s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516878 [ RunTime:0.002646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539313,1012303,852366,378711,832676,37928,522030,701419,895766,683038,275893,685983,1035068,167494,992,605490,296451,128355,69410,571181,929415,193702,151014,45158,83209,768804,78194,166747,119672,298809,646183,874326,850179,280499,84016,320277,325303,383476,210356,265695,30770,1021848,189092,746259,618133,891006,345330,381273,16758,782684,691279,62785,393019,293536,94415,38680,398057,666487,265093,721983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]