SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505169 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505169 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170653,882770,392227,504247,974313,626024,369676,443686,132784,871958,508100,12490,497429,43920,439143,776040,940898,951615,584415,708474,91494,533565,623024,116770,1029480,726184,648746,788955,573528,294349,407330,774240,371163,767481,450248,985580,808230,406039,309271,844419,436402,726855,498151,1005632,788181,458820,322331,1027688,638590,323296,927940,162063,135983,61083,462581,195770,793906,479187,247920,312681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]