SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475082 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475082 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599610,990878,742453,549522,277332,277312,782100,870774,179549,867844,480176,701842,430344,248459,671135,234512,1093,203693,780288,413264,6337,248902,596253,151573,863068,299413,488862,595993,649247,396681,957033,526895,331898,981010,729921,315151,913844,1036176,908542,249628,151161,1048353,806690,196101,688542,970125,625918,520278,880136,905010,102569,313852,574518,587859,808045,610853,995537,899039,863384,882504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]