SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5035 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5035 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384356,331181,783912,87950,852342,600616,753349,559226,512152,1043134,413217,310959,323586,1001417,771409,124521,1016862,114679,522003,198189,983955,876282,45733,11106,797766,388595,145217,187609,757512,636531,561923,28901,599926,601006,570238,308230,470928,498596,151983,1016738,291332,580551,153274,461673,505073,691250,256055,424443,199649,669235,106261,966437,330519,608377,571164,926266,934922,273782,37885,1002561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]