SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 988271 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 988271 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343055,424269,148848,383210,609181,1040441,557278,840436,865480,549135,720782,1040066,529423,492612,652249,424066,472584,843442,331552,162825,168072,82467,423894,404733,474623,982800,461482,681423,681896,396811,474308,1033569,1044450,200610,501297,224802,968354,207109,248901,765033,728059,292884,265670,109366,217868,188330,843251,464251,810538,754050,1047939,449604,325905,377900,998781,429054,656625,107561,450249,41941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 988271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 988271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]