SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802413 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802413 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639271,414145,171949,181582,50112,242476,752232,235665,628765,110525,542012,738624,208200,338818,238103,924693,839997,29988,192231,915995,477053,865467,884032,258200,185524,830216,63074,894522,746516,247967,887620,915425,374839,904172,639010,121483,231239,316850,70832,297672,648338,563963,776990,840815,97400,780683,106294,530628,701235,212762,84869,626322,386299,345338,579732,363199,655884,895817,412789,555117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001862s ]