SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578817 LIMIT 1 [ RunTime:0.000604s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578817 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472220,947933,842052,750551,858846,872750,1024154,1047131,777063,1039520,604539,846302,404872,57550,897073,811034,986060,892884,939741,972802,145350,929913,503663,503700,104133,621981,904074,80075,659775,489320,523784,604785,101789,1003936,500164,964061,40254,54399,958624,214343,289014,200153,676669,528859,40264,221525,793725,916771,310649,849508,978543,178392,34078,358516,5694,542317,47809,469490,1042168,17937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]