SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556211 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556211 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506951,944452,526989,545640,238203,219127,743356,475622,518813,972958,425006,263981,215742,272110,969775,107623,517175,261214,988225,316016,556776,50029,285340,143291,880212,24836,899785,1011166,17474,172567,813564,862421,910152,844784,235373,726537,791839,599349,578342,999177,648819,252222,732016,772844,1006083,559091,541309,933894,739568,146759,663269,19911,551977,107338,604041,672882,546827,209977,1040186,964855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002302s ]