SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491475 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491475 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844820,900473,99330,382250,805238,827395,371554,164563,427010,361566,563627,932685,353015,154416,16780,134362,331654,390982,583187,535119,817385,516313,35866,715293,561735,112025,1010285,694036,185464,939085,501436,920686,430604,291683,479430,734866,65410,263556,1029117,191538,505146,90476,128793,301236,508383,449045,1011798,989322,17022,1001932,77864,271057,221504,697273,630617,1011222,916477,407739,818826,234511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]