SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503481 LIMIT 1 [ RunTime:0.005697s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503481 [ RunTime:0.004974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288445,257165,933977,330045,117616,145986,519736,726965,669635,330393,753088,374779,598317,976173,254446,354742,982332,453597,38164,990356,156743,216281,820172,732390,993066,664597,301249,1010097,740614,6695,225279,440926,352639,139668,540218,565597,757312,428538,16224,227068,16134,1024882,1004481,911983,228821,157490,331316,310583,670716,834678,452853,383984,934727,925656,7973,726543,341525,955610,1036310,750651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001521s ]