SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504806 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504806 [ RunTime:0.002448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510176,70068,752600,58212,675712,667892,261624,136840,516784,68219,832370,836439,442799,418988,5255,1027757,443773,860417,98021,972349,933773,471471,596734,926771,569324,192419,775685,391120,247098,154580,694302,107915,724146,829325,965633,795983,264283,686037,799301,812217,297831,568891,1046158,795184,561367,400318,458848,830554,49504,18849,362301,675279,561626,823391,88102,981200,590720,39434,825267,149036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004089s ]