SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020134 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020134 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971630,436833,235928,795682,555562,850329,115305,178433,698325,94275,346192,364832,468881,779875,18910,276591,259780,935001,705451,375220,78289,548315,864727,408123,151134,67277,783480,120985,119209,405578,240924,126699,547939,600256,470447,376510,896876,401318,930746,866807,211823,783572,372169,421745,441502,124938,707687,369084,139967,758931,571630,555912,368445,728512,606303,705843,380989,495441,225171,620223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001116s ]