SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001968 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001968 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037485,95444,704185,854305,548649,600610,17352,651747,278897,919237,277984,900412,765413,681836,210165,176665,599606,846796,351557,535217,851248,226106,390699,46002,792158,712815,218713,43024,101944,455796,143221,709100,500185,392882,68371,76209,394265,119508,982746,678261,1036776,706706,472213,723000,24844,526247,678257,416008,414457,160518,136727,494541,555187,693008,5777,302690,445002,1032770,614623,325983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]