SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002688 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002688 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695916,288850,623239,1008580,447868,180906,270960,469345,501583,496172,1045250,995036,738269,769528,855012,64838,709054,501933,755488,70982,822054,299285,797213,16312,319757,739171,311209,252948,597168,368637,851000,875296,591400,463313,13467,768936,734151,587956,1034275,868689,603127,645510,476746,389215,159756,412205,326252,933260,378118,51911,195544,649219,725080,485487,1033538,839088,252019,842883,737692,1025162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]