SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631040 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631040 [ RunTime:0.002786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788670,525638,970365,381987,817101,511727,608421,552793,214481,355723,471071,322261,94000,737817,157953,139922,455018,956303,697639,945443,552083,924102,947975,140604,651485,551990,512195,903940,483631,330350,270293,767046,635473,321456,568819,50453,198817,250148,165013,978499,536281,927982,844166,224873,247931,265224,657461,905695,118588,419330,303537,462192,188681,291337,907452,32786,742394,102477,842873,1038760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]