SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047501 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047501 [ RunTime:0.005575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359312,1045719,920956,937419,761769,901788,802981,902218,516316,545129,751888,622187,274677,369555,959799,1035842,614112,847101,307250,925051,756702,472059,732858,473292,6424,599646,127470,934971,322648,92046,65683,546518,964114,181179,289869,827348,621473,410394,839739,268789,769326,1016844,888626,41280,156085,121236,614907,186352,35939,1028106,498936,603052,962563,274288,119569,440455,544060,800241,579166,807762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]