SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489154 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489154 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583649,591611,375657,835131,559108,705676,679746,943666,295321,394427,361996,170592,1022777,964757,380024,1028291,794645,467885,488472,668590,865993,817004,477132,381423,792012,488665,305105,432522,252991,637767,505520,1005951,353438,298580,759342,372305,965043,167558,574291,551315,161250,743707,617439,517031,656656,25897,504790,276948,780040,202821,502130,770798,519950,483791,894563,208306,812323,102331,140698,180840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]