SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421848 LIMIT 1 [ RunTime:0.001360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421848 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467325,682842,917471,816996,330429,555781,778366,751012,121184,293875,706606,911344,459911,173304,278051,536074,459192,514846,480711,252713,780214,245861,33843,619276,981801,800818,419496,446677,1013300,342098,1039561,836697,920134,764194,181787,402098,57312,563072,846963,470348,291054,685251,754948,67331,175138,125070,486447,365332,932774,192055,29620,477795,700412,535311,280265,868299,475853,992402,842985,445547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]