SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003748s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454001 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454001 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047853,1020621,804253,208493,400701,19374,58836,668546,293415,537362,475180,512907,495610,11832,811700,189146,919777,618861,232359,924496,154747,995714,105903,1001664,809074,85440,317576,435113,599311,49041,150566,879102,1038723,167538,579550,713588,124494,401543,356361,201229,286350,714034,394419,722531,696739,102484,514121,643640,11070,899337,430649,685783,256334,115809,1009628,166726,239016,852756,531157,895089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]