SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40971 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40971 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989110,34684,889309,549285,964089,1047231,132107,917868,919072,444161,45861,39432,79820,443038,780380,973054,202602,648659,470881,811810,43087,890120,584683,331947,281365,694479,88680,778601,656715,852037,264514,803333,903219,456380,794856,345075,257241,401926,935831,685313,766511,363571,443270,379757,912031,629056,819924,737404,249812,677605,205026,682235,296900,705427,544854,713626,715549,253917,16885,817571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]