SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294809 LIMIT 1 [ RunTime:0.004295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294809 [ RunTime:0.003098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623272,201881,382865,594119,159726,253547,976295,246576,87438,587456,855085,438115,423753,875726,58297,28233,479646,660300,598771,980275,803289,48425,357323,1016065,882424,730152,970934,518627,582245,69263,195374,185384,332579,652543,220291,218887,1002646,488471,652729,13990,409982,170766,435367,758947,550200,641310,206696,874614,6119,479309,441758,947722,952740,764421,527958,797349,77279,316891,65677,820098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]