SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344078 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344078 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440171,1038578,777695,69456,465233,1015294,1008009,161482,675222,947366,617298,523696,284378,972788,626524,750057,235302,194571,638215,451339,462802,345871,851144,787866,725267,633563,5784,162527,316923,504125,700419,247979,23716,305355,39641,303789,723451,634733,397822,716759,881085,103515,197331,365337,82399,686161,76125,196110,827745,526134,522403,1013166,346941,378339,274323,751739,310924,301076,911658,37229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]