SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469379 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469379 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41508,388027,993822,201661,316280,564465,819234,482241,696455,945909,801850,1043166,818629,877656,683283,1026042,358251,809717,80744,773261,754640,565252,769074,1024073,194708,931685,479508,4230,397191,38260,1006292,165417,1047513,107768,410439,75601,767690,958699,813994,1017725,476433,161150,655892,539780,457485,501326,781569,481201,253469,88890,915404,616803,1024810,769767,636807,613262,1034483,739162,945872,304773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469379 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469379 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]