SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804550 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804550 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289701,24765,508440,728453,871730,820059,490144,362112,878231,543025,988203,530509,905645,301834,176781,262260,580549,744166,647271,41131,679618,858226,289881,171941,255502,971218,153649,932775,321300,817676,110654,651498,154319,253088,542728,664371,1016946,1048028,866900,423583,44823,416769,993200,717885,245629,845207,239837,968874,447104,353115,238334,636492,729065,417056,200322,590777,255793,827166,308896,381888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000801s ]