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` = 1009160 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009160 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837173,312075,575684,422995,449996,205154,33505,858130,434745,583411,292793,105062,353578,305529,707973,847122,592871,842232,830051,845819,642948,129435,1020472,150042,168259,110109,102808,313885,347145,773733,649161,289801,1047194,275635,767364,1036917,339541,711411,414457,683050,143280,1025730,194932,496812,945494,880527,1010688,251114,578562,922570,414904,181090,974575,316726,8130,1013513,392563,895967,251571,77215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009422s ]