SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580381 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580381 [ RunTime:0.002706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260210,367507,35395,17243,395087,225061,837317,696762,54144,141154,890644,384966,399573,882545,799462,855510,520880,838883,542922,326166,397643,927523,1001526,1019824,427858,362568,477003,845897,134965,280097,183864,492342,900316,672596,80394,728963,606668,462092,255164,568791,610134,122824,752131,693465,141092,735118,463315,251896,792807,421202,328739,8750,524699,349903,527293,944357,815480,801870,596811,851932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001011s ]