SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296457 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296457 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520569,374432,707212,369931,261947,921668,654463,605693,292526,15756,11018,416247,311608,267759,90369,753693,759906,1020992,693015,116750,972688,1012874,1032212,974945,162599,478031,604560,576492,528744,736001,120482,496527,498472,399388,178382,339204,646750,144704,740553,208858,258050,979353,332186,175234,732171,535564,927050,908674,409415,968012,730568,793033,847519,473823,660895,1004367,339437,220155,876074,122077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]