SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486012 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486012 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119823,775337,87549,797040,495322,286826,491844,399289,404982,219724,997468,743350,762649,377888,290142,892554,294775,968802,818015,545139,1020684,471354,570346,564185,847461,892044,1036326,723999,993883,690647,382285,248112,225003,517610,846101,484078,1038259,93060,157089,795193,899388,781235,860148,29153,36353,771374,927802,459240,635586,112920,61528,82009,693543,382650,87548,109674,461133,1047444,141891,81376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000947s ]