SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430580 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430580 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934378,31194,606364,160471,933778,835884,282285,700675,103730,899659,854049,192673,479034,922697,820812,116231,572901,268329,842524,1046010,528087,598856,1025095,335956,902726,865795,996346,964484,19935,1013311,542907,63012,342917,807889,585866,294524,466107,178021,671754,36238,513761,315610,862661,29224,63955,457937,120222,581576,969097,225441,855888,619956,560311,1015666,747013,624471,98856,399557,342009,484484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]