SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017636 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017636 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335320,309304,480324,761912,470316,587773,730601,317363,1033229,325723,218144,190935,328333,996380,674742,721475,562863,497980,55000,385281,161307,397384,427016,1000530,972166,1047840,732026,405402,470589,521414,966010,401372,564187,75974,326719,545035,369920,548553,778826,679177,763088,444238,740160,558237,286135,724206,1033049,711780,872559,591787,877687,304029,125344,39579,530630,480048,481359,541895,1030306,978236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]