SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5250 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5250 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903180,34535,137280,401010,923229,486638,99710,934082,522921,567415,162890,824680,596145,340262,513952,400300,851965,1037715,296665,926209,555660,312387,160565,1002169,35432,42100,698238,360061,28419,23621,756527,600926,360467,275268,259958,14415,735176,418392,646751,463610,283005,385569,860898,587216,418153,713018,898341,1023594,693120,831885,674001,165376,128549,882997,865907,742788,216802,837534,833378,312195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]