SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047896 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047896 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494527,956540,128616,304172,581119,202670,189953,55934,547790,425653,91091,575979,359488,870174,760262,246638,393745,520736,725277,449433,427379,933116,940168,141335,190865,468545,1025018,419229,1022429,391975,455459,634898,736528,321648,406347,686883,229166,470035,441176,69446,863258,306282,973446,811503,229958,816964,574043,338675,581270,917889,1010214,608429,427135,570031,934954,206002,259905,663675,1027799,263148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]