SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043345 LIMIT 1 [ RunTime:0.004061s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043345 [ RunTime:0.004460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15429,571562,695837,734230,38867,219131,644375,323504,817007,370655,270404,401975,597010,587974,1011479,305124,539175,616324,132790,88593,640439,590373,1012692,602448,741584,1039093,666377,197611,402088,490169,310384,785394,380787,114094,198566,360585,879991,625240,897540,646612,682901,34310,482838,670541,441126,184859,856219,826426,845208,1005713,408447,188975,386636,70162,1020270,285774,26686,735010,756550,142800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043345 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043345 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002450s ]