SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313341 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313341 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477244,424748,162898,310294,124569,294814,606912,602652,542097,242623,655085,1018517,399651,421258,169936,660708,96128,179485,83109,88119,1010684,277962,243260,943224,18526,582307,101558,1045082,847002,809492,676895,898434,802468,804415,170882,174832,316718,540693,1034411,62067,1039450,426173,492790,443970,16698,733272,1024809,587679,477247,791310,952553,581525,1015217,889163,402363,458528,987357,187321,628138,192018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]