SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 127918 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 127918 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364212,369286,383457,51497,647304,275149,811460,406663,450067,830386,749717,415082,108580,334394,935132,1040142,152820,879179,614768,832297,433694,860800,820056,688374,998700,798289,554193,302247,54176,242751,316110,308285,766313,813758,505369,813300,41163,47882,198862,76213,25883,55527,235498,201533,185311,342291,1038,701663,882808,543913,105554,802758,474467,899252,948965,958714,575459,703260,681531,770585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 127918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 127918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]