SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98353 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98353 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244879,743022,140099,242357,920779,1013035,351925,483090,252359,297216,869780,617264,792670,145615,413714,100762,487966,300014,939703,842601,261583,733539,944736,378508,46888,160250,725799,1005292,499405,104173,518398,696327,405743,194893,1031315,339984,193359,152621,615537,226770,987948,862963,490459,497213,1043038,404277,355712,107651,669326,593548,642112,739924,82877,224429,108253,332588,931905,34256,175247,804800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]