SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003398 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003398 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477924,158004,867537,594288,407580,546110,1048147,113358,15427,469593,481803,561791,892859,299504,471290,28011,666403,392459,333787,221647,500294,265814,262079,138386,401253,908297,900322,998647,841078,849318,980334,422331,553732,381069,959072,120560,332332,1028770,982785,118209,822073,149210,791699,497051,418428,1025440,352382,275592,968059,98274,636372,696611,991496,609003,331756,728434,61485,608858,519304,500530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]