SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42920 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42920 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582047,915636,743030,17243,125165,354623,100692,687661,272711,808473,156619,807744,1027592,688175,770391,426642,540645,830519,129359,471124,282815,100245,790544,746400,165443,1044046,593595,469832,748044,36572,761212,981562,982604,335352,673475,1022291,152147,242468,1040516,650073,170651,928668,1040409,867282,244479,285855,737058,982487,304482,1033028,2346,839559,808777,340082,724952,483463,138486,1013538,868709,627774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]