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` = 502002 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502002 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150167,951599,590061,999286,130504,909369,562429,938681,107311,302980,852821,745787,115673,920816,238983,372176,135815,383539,298027,891713,741526,87035,808941,464304,692898,159728,666444,563271,614131,973100,229337,740126,70981,611275,1011154,675466,67259,187551,846910,179486,374400,129379,347167,389922,933678,477034,718195,955274,631014,233379,1000942,327790,62138,434730,990304,543799,586057,660296,451382,880960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]