SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419983 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419983 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347648,384684,173866,957329,646047,325747,970978,606306,28341,602794,485091,1030374,571741,476801,685195,494341,37519,368447,691270,402688,378039,956133,516138,415131,60717,15039,163107,727712,120371,645702,341205,1043547,364304,128376,385638,547192,703273,715936,515826,1028460,258315,627645,84948,669559,780474,724056,807955,236808,820369,622740,788165,842950,788950,359446,94961,245114,1005981,253592,412359,556847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000879s ]