SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3218 LIMIT 1 [ RunTime:0.001826s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3218 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383743,1002040,534943,942737,667977,72781,866914,849184,403486,1039227,781846,1008662,1006393,555390,432991,680554,353355,236654,466335,811855,1031581,363477,512955,561780,87592,947206,41559,367770,746402,533261,314625,806168,349431,88186,230783,975991,743242,462014,435167,470258,17438,38823,275217,925551,577512,1000268,312531,671000,807726,1034677,966403,101704,135644,784429,1006197,969051,1011893,728497,231636,764052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001579s ]