SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442041 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442041 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026357,961974,900169,181190,392464,481454,944581,689960,245646,403586,580053,79637,139458,355020,731104,291574,1007177,642273,625921,1031078,574150,303473,309472,578412,547309,59390,172716,443397,876304,342169,504869,83468,641946,635333,105151,933739,279213,177742,158150,845789,1015171,246735,247802,274416,112288,241703,650105,803007,109835,704252,849173,74650,528849,971401,811886,242906,871696,313858,919379,464170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]