SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467037 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467037 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51819,115970,1002702,871915,249286,1037318,208230,353662,432072,425704,431032,986872,901599,297302,721391,981710,713232,463712,761444,44583,767848,612529,330070,940587,646140,382806,1037210,188042,757442,143030,835751,643685,798340,239249,91883,708141,767603,908836,1003047,764809,228892,452804,169668,944887,298966,51203,674960,709628,379069,891664,199021,375416,199817,310345,59417,391620,736158,855604,43209,937742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]