SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428984 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428984 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919471,509358,278173,465768,434238,978488,492179,33234,221997,767652,146330,568524,216969,805528,462110,112581,600935,840335,834102,1031318,330061,748078,610131,211865,1016857,627533,715012,900063,597335,47609,578119,761600,187513,875633,192894,52812,94723,570058,28700,639189,8541,85831,870075,50215,256698,672322,397187,170437,514633,214747,426147,310741,34125,487853,341658,933052,739648,3960,251161,8832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]