SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042218 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042218 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457389,622908,185347,183645,1008403,1035909,1022730,13243,982828,889294,252505,364202,230030,852537,126112,230641,417057,625002,989767,485928,250753,395286,64144,290893,299140,957265,311797,82704,530609,1028454,1001109,438791,102402,624111,618199,595689,66685,7219,121189,581363,388060,628706,107073,604568,382291,819873,811911,435057,788441,650355,406623,965110,987186,229705,692154,733824,868283,708167,977654,983730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]