SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428080 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428080 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250969,1002735,293692,631420,375162,686227,626473,130152,581985,889449,380623,887701,526148,40224,268030,525678,961645,509255,400850,595452,746385,970454,241557,143492,912528,969653,81319,942547,202176,526839,964833,591180,669090,559127,692924,704228,35019,208411,175705,284468,614620,639386,75243,704393,1036586,343353,924601,824324,529763,759996,1019208,415508,287246,1046823,422011,646806,940549,621051,13524,905019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001057s ]