SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554568 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554568 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215717,31072,255641,134486,702802,384119,655946,694151,279206,68343,637108,64178,550174,116781,735190,964340,248120,675303,800423,132523,104802,593757,24654,924537,26683,983058,190613,414316,978448,479920,279879,378294,434455,719863,988121,647589,196678,436398,1013248,469647,57669,172813,151796,1039161,949295,33780,780522,597240,930611,740079,983167,514515,193363,720783,612164,908479,986993,288211,145478,671767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]