SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501591 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501591 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570836,148425,559481,237715,850243,420964,54412,338728,577250,155752,97842,82135,11774,538790,615477,802104,692828,694375,935676,591472,806714,452772,831638,309684,648751,452175,529954,718738,738159,883384,732183,1042963,979613,709232,526315,48829,184379,884701,817802,737281,131099,247709,786439,466146,263796,467125,83138,699851,1038380,710743,619061,610096,289674,296404,210930,774492,734975,858469,1048339,827996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]