SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021204 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021204 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6427,791825,14090,286394,227866,80966,154121,661039,225657,66746,890533,806019,561491,568479,275250,198728,220255,266321,85544,476022,101951,474910,839212,285169,367617,225965,891262,124310,519499,499152,669556,617721,665057,96358,862078,21684,102850,544479,222067,7492,724141,611352,275311,723586,111186,1004466,314723,416531,903254,463803,1036464,1045806,306225,91102,139112,1023073,112946,414407,401569,44314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]