SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478401 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478401 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359147,539126,549069,656511,1027252,331492,136300,343325,507807,153768,573638,635880,193941,272351,477019,561663,25597,800903,474911,492339,330048,610479,300885,684767,707318,297987,186885,463477,8990,75937,696261,15533,1023076,905941,145549,111966,981498,1034745,340768,289758,161668,167211,97563,311653,713402,195462,1007647,419967,348012,376694,937668,405547,734811,580936,673428,1013841,290475,416051,991186,1025077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]