SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105399 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105399 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95546,108241,150059,336330,952239,541977,753260,98455,912284,45190,448686,952516,663951,382688,240094,836045,593122,909700,26282,535490,143906,551426,335822,324461,1008583,936113,954792,797451,145779,849207,395546,521621,952607,605678,1024832,5633,461902,656294,941838,912138,179297,315692,833736,901198,813025,42483,255816,761584,1035373,1016800,934078,780429,505302,1028065,526129,885037,325747,234412,842716,50252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]