SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314200 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314200 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608800,982083,35260,411400,112515,955885,848236,699310,641371,137714,851586,804422,376638,1018471,218350,824397,775788,421170,562582,859284,837018,731202,365886,168636,715773,786220,1005770,396719,544337,73941,480529,687521,446226,590641,525620,663116,75337,869383,263468,232156,212101,250702,1041700,885032,472259,342942,574942,931538,560733,162498,43884,691307,433426,536196,267954,477916,578017,704856,24633,915011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]