SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405029 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405029 [ RunTime:0.002353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672641,820767,193850,1033532,598073,784107,444339,387327,555430,198845,528304,540952,511789,477869,941688,367785,982766,914016,641420,845226,564556,377782,550932,359603,977784,143208,79382,413802,909216,553888,119261,548700,816894,786457,945675,104859,473852,640057,523200,532088,393081,907876,83551,374286,947244,941183,239826,546158,217185,1023961,674022,656943,112656,740004,446633,209574,1033267,42230,190274,746117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]