SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511099 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511099 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939943,993845,195456,232101,479954,472738,246612,645160,224049,66536,417183,628404,475482,989440,619501,568319,283208,396729,637626,58776,723798,594269,836210,689455,250364,452989,493994,1028764,621079,104579,171075,553494,235446,461347,506659,252591,368447,390238,454988,556726,825736,517766,931024,503316,802504,385901,45528,828332,57644,188171,183097,753445,816289,887513,552996,297388,462873,42949,472620,1028553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]