SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438470 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438470 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220685,1038413,24946,174859,576870,201569,181670,578498,776615,981797,464410,1008802,340710,853865,1009848,472142,303834,944117,398035,605125,846359,336676,945027,51756,1023260,770104,209562,488682,1012649,783095,837330,726913,958431,644076,274900,595473,297944,543640,1026304,597309,711629,255,681638,365574,824683,384062,562495,277738,226458,1000105,650637,102797,372770,71752,908402,831357,65907,799286,1038947,770410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]