SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025436 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025436 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024708,958352,396138,925874,446717,741659,607787,571016,602726,238111,284216,518744,42939,815350,975060,782931,179268,681775,869276,822713,755052,672890,420471,456608,339193,506127,349709,581305,1028064,797770,391330,596202,865531,660005,809354,664523,686643,764088,229521,521539,510730,422422,88284,367510,439712,654053,443499,21654,1002262,84500,442468,776867,618680,577157,597432,317881,771344,271597,440278,433890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]