SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459711 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459711 [ RunTime:0.002769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351211,66374,381932,922111,1043762,76733,669850,888033,937765,264298,961292,306521,817414,611221,139012,404685,1034060,720531,72313,411185,148018,751164,317381,563680,318600,1045935,296330,989123,979843,609038,577245,735546,327805,991771,714569,420147,944230,435185,18211,101339,1034598,942211,357225,587782,411537,972701,772391,279433,771758,243905,371671,372332,50381,601116,997274,812745,807132,882124,162238,227161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]