SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200962 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200962 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211822,601802,622262,902173,799194,864165,265894,908267,1038062,922600,355670,453182,346243,504443,1028595,149960,50790,602277,115366,1044166,421237,265223,192000,765446,348731,349725,477509,884413,993445,681450,255995,724419,254361,76927,965539,568209,24601,87022,459896,849850,272503,875870,212334,115580,1006051,253349,27264,496659,479524,484134,716046,577013,737059,867497,256032,386627,554466,895953,301834,201418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]